Model Table INVENTORY VALUE
This model dimension represents inventory value and is based on the IFS Cloud
fact view FACT_INVENTORY_VALUE. All models that refers to this dimension will have
the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| CONFIGURATION_ID | |
| ID | Key. Built as CONTRACT_KEY+'-'+STAT_YEAR_NO_KEY+'-'+STAT_PERIOD_NO_KEY+'-'+PART_NO_KEY+'-'+CONFIGURATION_ID_KEY+'-'+LOT_BATCH_NO_KEY+'-'+SERIAL_NO_KEY+'-'+CONDITION_CODE_KEY. |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| REP_CURR_UNIT_COST | The unit cost for a reporting currency. |
| SERIAL_NO | The serial number of the part if there is one. |
| STAT_PERIOD_NO | Identifies statistic month of year. |
| STAT_YEAR_NO | The statistic year number. |
| UNIT_COST | This is the unit cost for the part. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| INVENTORY VALUE | FACT_INVENTORY_VALUE_TM | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE | Data Mart |